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 163 164 165 166 167 168 169 170 171 172 173 174

  1. Solved: My code start to be slow.
  2. Need help to insert column in Pivot
  3. Function, compile error.
  4. Solved: Need help regarding formatting sting using VBA
  5. Solved: Importing data from other Excel spreadsheets
  6. Solved: Cant get the value of a control in a multipage
  7. HELP to show formula
  8. Solved: Running Module from Other Workbook
  9. VBA Code to Hide Blanks in Pivot Table
  10. Solved: Time Stamp in cells using VBA
  11. Copy function
  12. VBA HELP
  13. VBA lookup and delte
  14. Delteing
  15. How to insert Japanese character to SAP from Excel?
  16. Using VBA to disable Save and Save As
  17. Dynamic Range Transpose Loop
  18. Solved: Excel 2003 Saveas Issue
  19. microsoft ado control & datagrid6
  20. VLOOKUP Between workbooks
  21. Need help with select case structure
  22. Help to a code - Save as - Debug
  23. Solved: Date, Month, and Time Stamp using VBA
  24. How to sort files before inserting to worksheet
  25. Solved: long function from excel to vba
  26. How to call\use DLL via vba macro?
  27. Solved: Find Text
  28. Formatting strings in cells
  29. RunTimeerror 2147417848 (80010108) Object invoked disconnected from its clients
  30. Refernce formula and formatting
  31. Linking macros to hyperlinks in VB
  32. Solved: Multiple IF statement (??)
  33. Save dialog in ppt
  34. Asking about VBA in Excel
  35. I need a Worksheet_Change macro moving cell to cell
  36. Code to Compare Cell Contents
  37. Solved: Is there a way of shortening my ever increasing vba
  38. If any column in active worksheet is hidden, then the value of cell A1 is “hide”.
  39. Solved: Range.Find returning Nothing
  40. Help with a macro
  41. Help with multiple criteria functions or VBA code.
  42. Remove Last Row Value From Sort
  43. Solved: Copy and Paste On Formula Result
  44. Solved: Copy a Range then Transpose Paste into every other Cell
  45. Export worksheet problem with path
  46. for loop returning 2 numbers
  47. Solved: Help uderstanding this loop
  48. [SOLVED:] Hex to Binary conversion, not using HEX2BIN
  49. Solved: separate specific symbols in order of priority
  50. Solved: Create chart on new sheet using VBA
  51. Is querying beyond 255 columns dead?
  52. Solved: placing formula in the same cell (D7) of all tabs
  53. Re arrange columns from selected rows
  54. Auto Start/Stop Macro at specific times
  55. Solved: Macro to remove entire if null value encounter in column
  56. VBA CODE ADD TO CODE MANDATORY CELL
  57. Worksheet_SelectionChange(ByVal Target As Range)
  58. Simulate mouse movements
  59. dynamic x axis "find last cell" vba code
  60. Extract Values of SN tags and save to Excel
  61. Solved: .FormulaR1C1 VBA
  62. Display tiff image on vba form
  63. Double click can edition in ListView
  64. CostCenter and Product combinations
  65. [SLEEPER:] Context Menu on UserForm
  66. mail from excel
  67. Solved: VBA Code : Help required
  68. VBA FORCE CELL NOT WORKING
  69. Excel DLL CUDA
  70. Link UserForm with worksheet data
  71. Solved: Used Range Selective ClearFormat
  72. Resize Chart as Picture
  73. [SLEEPER:] New Workbook for each worksheet
  74. Test if variable or object exists
  75. reload job nos fron jobs at J status
  76. Date Time copy paste not including time
  77. [SOLVED:] Need help for conversion
  78. Extract Web Page Data
  79. Solved: Copy data with values & paste in another worksheet
  80. Solved: Loop Until Help
  81. using excel to fill online form
  82. Copy worksheet cells from sub folders to new workbook
  83. Excel macro/VBA to sort a column, upload to sharepoint and save as draft on outlook
  84. Summarising of info from many w/sheets with a Macro
  85. Removing Spaces
  86. Solved: Repeat cells N Times
  87. [SLEEPER:] An MSForms Treeview
  88. Solved: VBA to delete a row in another worksheet
  89. Solved: Subfolders's names in array
  90. Solved: If cell is cleared or blank the conditional formating color is removed
  91. Solved: Draw without repeating words until the entire list has been drawn
  92. Solved: Help with Find/Delete Entire Row
  93. Solved: Incorrect VBA Sort on Workbook Close
  94. Problem Using Kill File
  95. How to get records in excel ADO
  96. Solved: Add date to Userform
  97. Solved: Help with automatically fill in cells by VBA loops
  98. Solved: Excel- align rows by column. Works but too slow!
  99. Solved: Worksheet Change Function: Created WS?
  100. Solved: Return a value from another sheet
  101. Solved: Remove Freeze Panes From Inactive Window
  102. [SOLVED:] Byref argument type mismatch array
  103. Excel Automation of IE - help click this button
  104. Solved: Double Click Event for Shapes
  105. Use a list from Excel to move files on computer
  106. Can not get rid of "Do you want to Save changes"
  107. Multiple currency format from UserForm
  108. VBA - CELL VALUES EXCEED 12 (MONTHS)
  109. Solved: Add third column to listbox
  110. Solved: sort columns dynamic
  111. vba to find and replace exact matches of cell value in a sheet
  112. Solved: user name
  113. Solved: Type mismatch error on If Not Range...
  114. Multiple Criteria Lookup
  115. group and hide blank space
  116. Special Sort needed - Sorting labels contained in one column
  117. [SLEEPER:] Disappearing calc field in pivot table
  118. Solved: change name tab office
  119. Solved: Function that's not working as should
  120. Attachment to gmail
  121. Solved: cell checking
  122. VBA - Macro to create/update documents in Lotus Notes database
  123. Export Selected Sheets to New workbook
  124. Running Macro Automatically if a cell value is True.
  125. Runtime err 1004
  126. OFFSET of result from vlookup
  127. datestamp on cell CHANGE
  128. Excel vba script to insert data into Outlook
  129. Multiple conditional values from Excel in VBA listbox
  130. Opening a new file of a different format
  131. [SOLVED:] Excel chart - identify the selected data point through macro.
  132. VBA Excel HTML e-mail?
  133. pivot vba
  134. data send to zohosheet
  135. Capture window help
  136. Solved: Sort All sheets in a workbook
  137. VBA Show All Data
  138. CONDITIONAL FORMULA with Percentage
  139. execute macro if change to range
  140. Text Box, text formatting
  141. conditional formatting text conditions
  142. Line list box
  143. RunTime error 462 - The remote Server machine does not exist.
  144. Muti Solver VBA
  145. Remove gaps in a combobox list
  146. Solved: Use a spreadsheet specifies interval even if another is active
  147. Embedded gif in userform
  148. Solved: EASY VBA ISSUE TO FINALIZE THE IMPLEMENTATION OF THE MERSEENE TWISTER RNG
  149. Merseene Twister VBA app easy issue to solve (with zip file)
  150. Compile error: Expected line number or label or statement or end of statement?
  151. [SOLVED:] Getwindowstext and settext
  152. Help with code to copy to another worksheet
  153. Consolidate data from different excel files (VBA)
  154. Solved: Make folder path and file name with VBA code
  155. Solved: Refresh my pivot table
  156. [SOLVED:] search folder structure and return paths only
  157. Solved: Application or object based error
  158. Paste special data till last updated row
  159. Solved: Smallest 3 numbers in range
  160. Class Modules in AddIn .xlam
  161. Save As Query
  162. VBA Form that uses data from a worksheet
  163. [SOLVED:] Copy from excel to word unmerged table
  164. Solved: Empty Cells Will Not Delete
  165. Solved: VBA Pogress Bar
  166. code created text box not firing change event
  167. ContextMenu example errors
  168. repeated user input
  169. how to get profit as per fifo method
  170. Simple VBA Statement
  171. Macro to fill values of row numbers in a 10x20 grid
  172. Using HLookup
  173. Solved: New procedure at end of code?
  174. Solved: Insert header rows
  175. Help with Sorting by first name
  176. Get HTML Code into String from Newly clicked webpage (i.e. URL doesn't change)
  177. [SOLVED:] Countif? within a loop
  178. PIVOT table - Change sub column label
  179. HELP, user-defined type not defined
  180. Solved: Getting average of a range within a loop
  181. Get last row of a page
  182. Unexpected "Subscription out of range" error
  183. Creating Summary/ VBA code
  184. Solved: Fetching data from excel
  185. Passing Array Issues
  186. Solved: If statement
  187. Solved: worksheet tab options unintentionally disabled
  188. Excel 2003 User Defined Function
  189. Solved: need help with finding the minimum in a 1D array
  190. Solved: Array Formula Question
  191. Select an item from a website tree
  192. Solved: Macro Equation
  193. Solved: Remove certain charachters from a cell
  194. adAsyncExecute apparently gets cut off
  195. Protecting Cells With A Password In different Work Sheets With Code?
  196. Treeview in 2010 64Bit
  197. Solved: copy entire row to new sheet along with header
  198. [SLEEPER:] Run Time Error '76' - Path Not Found
  199. Solved: Show All Data From Two Columns Matching Todays Date In A Msgbox
  200. Solved: Status Bar Message With Extract Macro
  201. Solved: Making a macro compatible among multiple users
  202. Solved: Show the working days without holidays
  203. Add signature to email
  204. Copying and Paste files
  205. Solved: Error while printing pdf from excel
  206. Solved: Change the place of alphabets to numeric
  207. [SOLVED:] VBA code for pivot filtering
  208. VBA Prevent File From Saving
  209. [SOLVED:] Working with String in VBA
  210. Solved: Popularize Listbox using Textbox
  211. Programming for the null case
  212. Find the Max Value when a cell contain Text and Number
  213. Solved: VBA to remove duplicates as per the date
  214. [SOLVED:] Matrix Multiplication of Arrays
  215. Displaying Search Results
  216. [SOLVED:] Solved: Change selected cells to common range
  217. Solved: Sorting data problem...need to sort at midpoint of data table
  218. Read Excel using SQL Statements
  219. Generate HTML email with file attached - please help
  220. Clearing Auto-Filter with Password Protection on
  221. Solved: Macro not working properly
  222. Solved: OLEObject Vlookup help
  223. Userforms, Listboxes, Virtual space.
  224. Add-in file path Excel 2000?
  225. Help with crating a tab based on cell value
  226. Solved: Setting Pivot Table Filter with VBA
  227. Solved: How to use VBA to test if a number is a prime or not?
  228. help with Payroll employees
  229. Solved: file name via function
  230. Saving the return value of oracle function in a string
  231. Count unique values based on another column
  232. Putting Values of 3 columns into one column using If ElseIf statements
  233. VBA to delete multiple rows based on multiple criteria?
  234. VBA Or Macro: To format data in a column and delete columns and create new column
  235. Compare one column with one cel and input result on a second column
  236. Solved: Obtain Pivot Table Cell properties with VBA
  237. set color saturation of image with vba
  238. Solved: Worksheet change copy to next cell
  239. Turn an image into a toggle button
  240. [SLEEPER:] Z Axis of 3D Graph
  241. Solved: Formatting Data Imported From Web
  242. Question on Formula
  243. Solved: open with filedialog and copy to my workbook
  244. Google Maps, inputting destinations
  245. Copy cell range to anther sheet containing;..
  246. Help with Copy and paste
  247. error in displaying value on a cover page
  248. Copy data in a Filter table then email it
  249. Copy from Listbox to empty sheet
  250. Solved: Conditional formatting, if cell1-cell2>0.2