PDA

View Full Version : Excel Help



Pages : 1 2 3 4 5 [6] 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162

  1. Solved: Open UserForm from an Add-In
  2. Solved: How to fix last row in a worksheet
  3. Solved: count the number of cells in a row that are not empty
  4. Solved: Saving as .csv
  5. Solved: Problem with "ReDim Preserve"
  6. Solved: Solved: count how many cells have been merged to make one cell.
  7. Page footer: page one of x, sub page 1 of 2
  8. Solved: arrange sheet names in sequence
  9. Solved: Overflow error 6
  10. Solved: Remove Macros from a workbook with VBA
  11. Solved: VBA Code Library (this site)
  12. Add new record in spreadsheet
  13. Solved: Hyperlink on sheet 1 to sheet 2 in same workbook?
  14. Can you hyperlink to a hidden sheet?
  15. Excel-Outlook-Access Link
  16. Solved: Summarize data. VBA CODE
  17. Solved: A harder Hyperlink question.
  18. Excel **
  19. How to create a sort instruction
  20. Solved: open notepad, select all, copy, paste in excel
  21. Solved: write cell address in text file through vba
  22. Copy a range of cells in a for loop
  23. Get server name
  24. Shuffling Data onto a new Worksheet
  25. Solved: John Walkenbach's FaceIDs Display
  26. Solved: delete all non-matching sheet names
  27. Solved: display progress bar
  28. Solved: get sheets name
  29. detect and change column width
  30. Help with optimizing formulas and workarounds...
  31. Solved: How to NOT Plot a Cell with Formula = Blank
  32. Solved: Problem Formatting Date for Display
  33. Could not find installable ISAM
  34. Solved: Another sumif - sumproduct delima
  35. Solved: Shared workbook
  36. GetOpenFilename multiselect
  37. Solved: Cant determine a cells contents
  38. Select given month in various years
  39. The difference between Hidden and VeryHidden
  40. Read-Only ... Shared Access ... etc Problem
  41. Total in user form
  42. Solved: Populating csv. file with text values
  43. Adding a Column Total to a Printed Report
  44. Solved: Copying cells when switching to excel
  45. Solved: Transposing Data
  46. Solved: comparing text to cells but only partial match
  47. Solved: Multidimensional Array Initialization
  48. sort and create new sheets from CSV data
  49. Solved: Clear contents of cells
  50. Select and delete
  51. Solved: Hiding Rows with a special column? (Please see attached.)
  52. Solved: Border around a range of cells
  53. EXCEL - Converting Hrs:Mins to general/currency value
  54. Move Cursor Of Second Sheet As Per The First Sheet
  55. Solved: Problem with simple loop!
  56. launching xls via shortcut duplicates macro prompt
  57. Solved: Header
  58. Auto formatting
  59. dates and times
  60. Help combine workbooks into 1
  61. Simple Hyperlink Question
  62. A (fiendly) Challenge to brettdj
  63. Solved: Click AutoShape and close the workbook w/ option to save.
  64. Solved: Chart Limitations (Plotting from Arrays)
  65. Solved: insert VBA code in new Workbook via VBA
  66. Solved: MACRO FOR FIND AND REPLACE
  67. Solved: Is there a way to retrieve the product key.
  68. making this code more dynamic
  69. Solved: remove any formatting from cells
  70. Solved: Interior.ColorIndex
  71. Solved: Is there a Scroll Event?
  72. Solved: Clearing Cond. Fmts from a Range
  73. Excel formula
  74. Solved: Can VBA Statements Be Stacked?
  75. UDF's
  76. Solved: cell formatting row wise
  77. Solved: check if the text is ALL UpperCase (UCase)
  78. Solved: Concantonate Cells
  79. Solved: Selection.Font.Bold
  80. Solved: keyboard shortcut to skip through sheets in a open MS Excel workbook
  81. Solved: Find everything to left of ":"
  82. Solved: open path given in txtbox1
  83. Solved: Conditionally Color Drop-down Choices
  84. Solved: Defined Name Errors...Please Interpret
  85. Solved: Can't Create New Sheet by "Running" Macro
  86. Solved: Determing Array Size
  87. loop through range to copy/paste hyperlink
  88. Test cells for scientific formatting
  89. Opening Template
  90. Solved: Check sheet names and display MsgBox
  91. Solved: select - deselect chkboxes
  92. Solved: Help with case statement
  93. Pivot table naming causing error
  94. Urgent: Excel bombs out when I try and Save the workbook
  95. colour From LEFT to RIGHT of a cell starting from where a COLON is found
  96. Solved: VBA Like statement
  97. Unable to focus on another sheet
  98. Solved: Need Help with a Change Event
  99. Solved: Format summary lines
  100. Solved: Worksheet VBA naming
  101. need help with VB script, error on cancel..
  102. Solved: How to link to a file one folder up.
  103. Printing to PDF
  104. Solved: Clear cells based on length of cell
  105. Solved: Data Validation List
  106. Transfer to a Different Macro When Stepping Thru Execution
  107. External Data Help
  108. Solved: Font.Size
  109. Solved: Add to a stock symbol
  110. Solved: Help finding the last cell in a range.
  111. help with copy import script
  112. Solved: VBA: Put Day in Footer/Header
  113. Forcing Hyperlinks to Open in a new Window
  114. Solved: Lock Column or Rows (Editing restriction)
  115. Can not open excel ss
  116. Solved: Macro sends sheets to printer in ascending order, but they're not printed so.
  117. am I doing this right ? del sheet if there, else...
  118. Solved: Passing Variables through sheets
  119. Checking Checkbox values
  120. Solved: Subtotals
  121. Home key action
  122. Security issue
  123. Solved: Help linking page
  124. Solved: Why is this text and not number?
  125. Solved: DatePart (Format Standard Date Time)
  126. The sound played upon displaying a msgbox
  127. Check for Blank Cells in Column
  128. Auto capitalization not working
  129. Solved: Progress Bar / Status Bar
  130. Solved: Populate ListBox from Excel Column
  131. Solved: on error behaviour
  132. Solved: Range Dynamic Query
  133. find a string
  134. Trigger event when rows are inserted or deleted
  135. Solved: Print Macro
  136. Using TextBoxes for Numbers
  137. Solved: Sort Alphabetically List Box
  138. Multiple Value List Box
  139. Solved: Long Loop Time
  140. Close Workbook and via Close Excel
  141. Dependent lists in order to restrict choices
  142. Solved: Pass value to sub in .xla
  143. Print Log
  144. Solved: Help with Lookup
  145. Getting one cell to stay on top of all sheets
  146. Solved: Array Function?
  147. Easy Cell Reference - "Guide" Lines
  148. Multiple Charts with dynamic ranges
  149. Filter ListBox Items
  150. Input Box asks for input twice!
  151. Look right until there are no more cells with content
  152. search string 2
  153. Solved: boolean true
  154. Clean and speed up code.
  155. Solved: Document workbook Properties
  156. Insert Object
  157. Solved: Send Link?
  158. Solved: VBA Naming Convention; Parameter; ByVal & ByRef;
  159. Word object in Excel
  160. Copy and paste
  161. Solved: The equivalent for CInt for creating a long
  162. Solved: Using Lookup command I think
  163. Solved: Conditional Formatting
  164. Accessing an Excel Module
  165. sort worksheet by suffix
  166. Solved: How to install Calendar Control 11.0
  167. User defined range and sheet
  168. Solved: How to force the user to make entry(ies) in a specific worksheet before continuing?
  169. Solved: get all sheet names in comboBox of activeworkbook and export when selected
  170. Solved: Automatic launch of a MsgBox
  171. Print to different printer based on cell value
  172. Adding Time written with Text
  173. Solved: formatting MsgBox
  174. Solved: Problem with "On Error" Not Trapping
  175. How to insert rows based on different values
  176. Solved: How to cut one sheet's values and paste it in other sheet?
  177. function defintion in comment
  178. Need help with date manipulation
  179. Sorting sheets by month from different workbooks into one
  180. Solved: Convert Decimal To Binary
  181. For Moshe - Adjustment to Hyperlink KB Code
  182. TicTacToe Smarts
  183. Solved: chk sheet names of 2 wrkbk & delete if not matching
  184. help with macro please
  185. Solved: Copy from multiple sheets paste to new Sheet
  186. Solved: Tab Column in VBA Form
  187. selecting cells
  188. pivot table summarizing by sum
  189. display correct toolbar icon on starting excel application program
  190. using vba variable to create data series for pi and bar graphs
  191. Solved: CD-ROM - List File Attributes of Directory and Subdirectores (like brettdj's KB)
  192. Solved: Solved: Opening Text files
  193. Solved: Decimal Type ?
  194. Solved: Sorting macro
  195. Solved: Code. Advanced Filter Criteria Non Adjacent Cells
  196. Checking that a document in Word was printed from Excel?
  197. Solved: VBA: Program to Identify duplicate entries
  198. Solved: compile error: vba VIA vba
  199. Solved: Combobox help
  200. Application.ScreenUpdating
  201. file opens as read only
  202. Compare 2 sheets different sizes
  203. Problem in coding
  204. Copy all sheets (filter some rows)
  205. open web browser with specific address
  206. Add unprotected rows to protected sheet
  207. Conditional formats to make things easier on the eye
  208. Solved: Question About the "Resume" Statement
  209. copy all files in a directory
  210. Solved: Run Outlook from Excel
  211. dynamically write data in cell
  212. Solved: How to do sorting by values?
  213. Solved: Placing cursor in a specific textbox when form opens
  214. Pivot table (data range).
  215. clear cell ranges if reference cell changes
  216. adding a sheet
  217. Solved: Automatically rearrange columns
  218. conditional rows deleting
  219. Solved: Crazy Request
  220. Solved: Enable CTRL+HOME, CTRL+END
  221. Solved: Pitfalls of Earlier versions of Excel
  222. Solved: Change Font of UserForm1
  223. Solved: cell formating
  224. Solved: Output GUI Components' Names of Form
  225. Solved: Call Function
  226. Solved: Assign Macro to Button on Spreadsheet
  227. Solved: Grid Box
  228. Solved: Rounding up question
  229. Solved: A Looping Question
  230. MACRO's and Dates
  231. [Help] A loop question & write texts
  232. Solved: eliminating blinking cursor in UserForm Text box
  233. Solved: Differrences between Rnd and Randomize
  234. my firefiter
  235. Solved: Finding selected optionbutton on a userform
  236. Enter Data In Worksheet & Delete Empty Rows
  237. How could I fill automatically a column using VBA?
  238. Solved: Validation bugbears
  239. Solved: Unprotect cell
  240. Copy columns to new sheets
  241. Copy data from one file to another in Excel
  242. Solved: Mapping old to new with VBA
  243. Solved: Formula wont copy down correctly
  244. Solved: Print all sheets
  245. Solved: List Box - Row Source
  246. Sub & Function
  247. Solved: Read Each Row Output Text File
  248. Solved: Clear Cells Except First Row
  249. Solved: Activating a pop up calendar by clicking in a cell
  250. Solved: Two Dynamic Named Range Copy/Paste